<?php
###############   COPYLEFT GPLv3 LICENSE   ###############
##
## JFX Version 0.2.7
## Website Management Software
## www.jfxcms.com
##
## Copyright 2009 GPLv3 - http://www.opensource.org/licenses/gpl-3.0.html
##
## Anthony Gallon
## oi_antz@hotmail.com
##
## Permission is hereby granted to any person having a copy of this software
## to freely use and modify as required so long as the copyright notices
## and branding remain intact.
##
## Full license details available at http://www.jfxcms.com/license
##
###############   COPYLEFT GPLv3 LICENSE   ###############

$THEME->addBreadcrumb($this->adminUrl.'/workspaces/list', $this->lang('ap_title_workspaces_list'));

$workspaces = $DB->fetchAll("SELECT * FROM {$CONFIG->dbprefix}workspaces ORDER BY title ASC");

foreach($workspaces as $k=>$v){
    $users = $DB->fetchAll("SELECT * FROM {$CONFIG->dbprefix}admin_users_to_workspaces WHERE workspace_id = '{$v['id']}'");
    foreach($users as $key=>$val){
        $users[$key] = array_merge($val, $DB->fetchRow("SELECT * FROM {$CONFIG->dbprefix}admin_users WHERE id = '{$val['user_id']}'"));
    }
    
    $workspaces[$k]['users'] = $users;
}


$SMARTY->assign('workspaces', $workspaces);

echo $SMARTY->fetch('admin/workspaces/list.tpl');
